Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. What dialog box allows you to change a field name in a PivotTable?
  1.    Field Options
  2.    Field Pane
  3.    Field Settings
  4.    Field Structure
 Discuss Question
Answer: Option C. -> Field Settings




Question 2. What command allows you to highlight the cell(s) in a data table that matches your set-up information?
  1.    Cell Styles
  2.    Conditional Formatting
  3.    AutoFormatting
  4.    Data Table Styles
 Discuss Question
Answer: Option B. -> Conditional Formatting




Question 3. Which of the following is NOT a box in the PivotTable Fields List?
  1.    Column Labels
  2.    Report Filter
  3.    Values
  4.    Formulas
 Discuss Question
Answer: Option D. -> Formulas




Question 4. Under which tab and in which function group will you find the option to insert a Pivot Table?
  1.    Under the Insert tab in the Tables group
  2.    Under the Formulas tab in the Data Analysis group
  3.    In the Data group in the Pivot Tables group
  4.    In the Data group in the Tables group
 Discuss Question
Answer: Option A. -> Under the Insert tab in the Tables group




Question 5. What function displays row data in a column or column data in a row?
  1.    Hyperlink
  2.    Index
  3.    Transpose
  4.    Rows
 Discuss Question
Answer: Option C. -> Transpose




Question 6. Merge cells option can be applied from
  1.    Format Cells dialog box Alignment Tab
  2.    Formatting toolbar
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above




Question 7. How can we provide a dynamic range in 'data Source' of pivot tables?
  1.    Create a Named range using Offset function
  2.    Base the pivot table using the Named range created in Step 1
  3.    Both A and B
  4.    None
 Discuss Question
Answer: Option C. -> Both A and B




Question 8. What is the purpose of using a pointer in a data table?
  1.    It highlights the cell that matches the source data
  2.    It allows the array formula to be repositioned
  3.    It highlights the first cell with a potential error
  4.    It resets the file location to a recognized folder
 Discuss Question
Answer: Option A. -> It highlights the cell that matches the source data




Question 9. What is the first step for creating a Pivot Table?
  1.    Clicking on the Insert Tab and inserting a Pivot Table
  2.    Create or select data that needs to be analyzed
  3.    Deciding on which fields (column and row labels) to use to analyze the data
  4.    None of the above
 Discuss Question
Answer: Option B. -> Create or select data that needs to be analyzed




Question 10. Which function will you use to enter current time in a worksheet cell?
  1.    =today()
  2.    =now()
  3.    =time()
  4.    =currentTime()
 Discuss Question
Answer: Option A. -> =today()




Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0