## Réviser les assessments

Total: 116 questions

4093 - On an Excel Spreadsheet, what is the intersection of a row and a column called?

- Row
- Column
- Value
- Cell

Correct answer: 4

Level: 1. beginner

Pillar:

4095 - Which Excel function calculates the numbers of entries in cells that are in the number format?

- Sum
- Average
- Both A & B
- Count

Correct answer: 4

Level: 1. beginner

Pillar:

4097 - Which Excel chart is best suited to display percentages represented by category?

- Column Chart
- Pie Chart
- Line Chart
- None of the Above

Correct answer: 2

Level: 1. beginner

Pillar:

4099 - Which feature in Excel arranges the list of names in a column in an alphabetical manner?

- Filtering
- Format
- Sort
- Pivot

Correct answer: 3

Level: 1. beginner

Pillar:

4101 - In Excel, what does A1 reference style represent?

- A refers to the row as letter and 1 refers to the column number
- A refers to the column as letter and 1 refers to the row number
- None of the above
- Both A and B

Correct answer: 2

Level: 1. beginner

Pillar:

4104 - To calculate the largest value in a given list of numeric values, which Excel function will be used?

- MAX
- MIN
- SUM
- COUNT

Correct answer: 1

Level: 1. beginner

Pillar:

4112 - Which tab on the Excel Menu Bar is selected to create a chart?

- Chart Wizard
- Number Wizard
- Cells Wizard
- Excel Wizard

Correct answer: 1

Level: 1. beginner

Pillar:

4114 - When we create a new Excel file, what is the default sheet labelled as?

- Sheet1
- Blank
- Excel
- Dummy

Correct answer: 1

Level: 1. beginner

Pillar:

4118 - Which term best refers to an Excel File?

- E-File
- Word File
- Spreadsheet
- Workbook

Correct answer: 4

Level: 1. beginner

Pillar:

4120 - How can you add number values in a range quickly in Excel?

- Use the Sum Function
- Individually select each cell value and then Sum it manually
- Use the MAX function
- None of the Above

Correct answer: 1

Level: 1. beginner

Pillar:

4122 - What is the shortcut key to undo an operation in Excel?

- CTRL+C
- CTRL+V
- CTRL+Z
- Shift+P

Correct answer: 3

Level: 1. beginner

Pillar:

4127 - What is Format Painter used for?

- It copies data from one cell to another
- It deletes the value in a cell
- It copies format from a cell and applies it on another cell
- None of the above

Correct answer: 3

Level: 1. beginner

Pillar:

4129 - Which terminology is not used in MS-Excel?

- Worksheet
- Cells
- Columns
- Slide

Correct answer: 4

Level: 1. beginner

Pillar:

4131 - Which of the following is not an Excel Function?

- COUNT
- MAX
- SUM
- AVG

Correct answer: 4

Level: 1. beginner

Pillar:

4133 - If you want to Bold value(s) in a cell or multiple cells, which command will you execute?

- CTRL+B
- CTRL+A
- CTRL+C
- CTRL+V

Correct answer: 1

Level: 1. beginner

Pillar:

4139 - Which option represents the Cell address:

- 5 2
- E2
- 25
- 2E

Correct answer: 2

Level: 1. beginner

Pillar:

4142 - Which Excel Function will take date as an input and return a number to represent the day of the week?

- WEEKDAY
- DATE
- YEAR
- WORKDAY

Correct answer: 1

Level: 2. intermediate

Pillar:

4144 - Every function of Excel must start with ____

- A less-than sign (<)
- A minus sign (-)
- A parentesis ()
- None of the above

Correct answer: 3

Level: 2. intermediate

Pillar:

4148 - Which function of Excel will get the serial number of today’s date?

- TIME
- NOW
- TODAY
- DATE

Correct answer: 3

Level: 2. intermediate

Pillar:

4150 - If you automatically want to highlight numbers greater than 100 in Yellow color, which operation will you perform?

- Conditional Formatting
- Format Painter
- Filter
- Merge and Center

Correct answer: 1

Level: 2. intermediate

Pillar:

4154 - What operation does the CONCATENATE function perform?

- It adds number values from multiple cells
- It averages number values from multiple cells
- It combines text or number values from multiple cells
- It split a single text value into multiple cells

Correct answer: 3

Level: 2. intermediate

Pillar:

4156 - What Excel function is used to calculate the length of the text string in a cell?

- LEN
- RIGHT
- LEFT
- MID

Correct answer: 1

Level: 2. intermediate

Pillar:

4162 - You are editing an already saved Excel Workbook and you don’t want to overwrite the changes. Which command will you use to save the edits in a new version?

- Edit As
- Save
- Save As
- This functionality is not possible in Excel

Correct answer: 3

Level: 2. intermediate

Pillar:

4164 - What will happen if rows 3 and 4 are selected and then we right-click and Select “Insert “ option?

- Two Rows will be inserted after Row 4
- Two Rows will be inserted after Row 3
- Two Rows will be inserted before Row 3
- Two Rows will be inserted before Row 4

Correct answer: 3

Level: 2. intermediate

Pillar:

4166 - What will happen if Column A and B are selected and then we right-click and Select “Insert“ option?

- Two Columns will be inserted before Column A
- Two Columns will be inserted After Column A
- Two Columns will be inserted before Column B
- Two Columns will be inserted after Column B

Correct answer: 1

Level: 2. intermediate

Pillar:

4168 - Which of the following is true for Conditional formatting?

- Find bold values and apply italics
- More than one condition can be implemented in a worksheet
- You can change color of a cell if a specified condition is met
- Both B and C

Correct answer: 4

Level: 2. intermediate

Pillar:

4170 - Which operation will you perform to lock the data in your cells from being edited?

- Password protect sheet
- Freeze panes
- Conditional formatting
- None of the above

Correct answer: 1

Level: 2. intermediate

Pillar:

4172 - Which excel function is used to count cells that match a certain criteria?

- Count
- CountA
- CountBlank
- CountIF and CountIFS

Correct answer: 4

Level: 2. intermediate

Pillar:

4174 - If you want to filter values based on two or more conditions what operations will you perform?

- Filter and apply conditional formatting
- Filter and sort
- Use advanced criteria filter
- Any of the above

Correct answer: 3

Level: 2. intermediate

Pillar:

4177 - For example, $C$12 is the cell address. What does the $ sign represent?

- The column address will remain constant
- The row address will remain constant
- Both the column and the row address will remain constant
- It doesn’t signifies anything

Correct answer: 3

Level: 2. intermediate

Pillar:

4179 - What will this return the following:

=SUMIF (E1: G1,”<10)

- It will return the Sum of cell values from E1 to G1
- It will return the Sum of cell values that are equal to 10
- It will return the Sum of cell values which are less than 10
- It will return the Sum of cell values which are greater than 10

Correct answer: 3

Level: 2. intermediate

Pillar:

4183 - Which function is used to calculate the sum of values based on some condition?

- SUM
- SUMIF
- COUNTIF
- SUMPRODUCT

Correct answer: 2

Level: 2. intermediate

Pillar:

4185 - Which is incorrect for a VLOOKUP function of Excel?

- It is a built-in function
- It’s a vertical lookup function
- The algorithm of vlookup explorers the value from the rightmost column
- The algorithm of vlookup explorers the value from the leftmost column

Correct answer: 3

Level: 2. intermediate

Pillar:

4187 - Which of the following would result in a #REF error?

- =INDEX(A2:D8, 1, 2)
- =INDEX(A2:D2, 2)
- =INDEX(A2:A8, 1, 1)
- =INDEX(A2:B8, 1, 5)

Correct answer: 4

Level: 3. advanced

Pillar:

4189 - Briana asks if anyone knows how to find the name of the winner, rather than check each name to see if they won. Using your knowledge of INDEX-MATCH functions, which of these formulas would you suggest to her?

- =INDEX(A3:D7, MATCH(“Won”, A3:D7, 4), 1)
- =INDEX(A3:D7, MATCH(“Won”, D3:D7))
- =MATCH(D3:D7, INDEX(“Won”, A3:A7)
- =INDEX(A3:A7, MATCH(“Won”, D3:D7, 0))

Correct answer: 4

Level: 3. advanced

Pillar:

4193 - If the value you are looking up is not found, VLOOKUP will return

- #VALUE!
- #N/A
- No Value
- #error

Correct answer: 2

Level: 3. advanced

Pillar:

4195 - To find the best results in an approximate match through VLOOKUP we have to sort the data by which order?

- Descending
- Ascending
- Both
- Neither

Correct answer: 2

Level: 3. advanced

Pillar:

4197 - Which lookup function is used to search value in the row?

- HLOOKUP
- VLOOKUP
- Both can search in row
- None

Correct answer: 1

Level: 3. advanced

Pillar:

4199 - Which lookup function is used to search value in the Column?

- Hlookup
- Vlookup
- Both can search in row
- None

Correct answer: 2

Level: 3. advanced

Pillar:

4203 - If the range B1:B3 contains the values 15, 35, and 38, then what will return the following formula:

=MATCH(35,B1:B3,0)

- 35
- 2
- 3
- 0

Correct answer: 2

Level: 3. advanced

Pillar:

4205 - The MATCH function syntax has the following arguments:

- Lookup Value
- Lookup Array
- Match Type
- All of above

Correct answer: 4

Level: 3. advanced

Pillar:

4207 - MATCH returns the position of the matched value within

- lookup_Row
- lookup_array
- Column
- Row

Correct answer: 2

Level: 3. advanced

Pillar:

4211 - When using an Array Formula, you press:

- Ctrl+Shift+Enter
- Enter
- Ctrl+Shift
- None of above

Correct answer: 1

Level: 3. advanced

Pillar:

4213 - An Array Formula will show ______ around the formula in the Formula Bar

- Square brackets
- Curly brackets
- This formula is without brackets
- All of above

Correct answer: 2

Level: 3. advanced

Pillar:

4215 - Which of the following chart is suitable for comparing multiple categories and data series:

- Line chart
- Column chart
- Stacked column chart
- Bar chart

Correct answer: 3

Level: 3. advanced

Pillar:

4217 - Cons of Stacked chart are:

- Difficult to compare all but first series
- Become visually complex as categories or series are added
- A and B
- Can show change over time

Correct answer: 3

Level: 3. advanced

Pillar:

4219 - Pros of Stacked chart are:

- Can show change over time
- Difficult to compare all but first series
- Multiple categories and data series in compact space
- A and C

Correct answer: 4

Level: 3. advanced

Pillar:

4231 - When the user clicks a button, _________ is triggered

- A Method
- A setting
- An Event
- None of the above

Correct answer: 3

Level: 3. advanced

Pillar:

4235 - When would you use FALSE as 4th parameter in VLOOKUP?

- When lookup list is not in any particular sort order
- When lookup list is in any particular sort order
- When lookup list is in an ascending order
- when lookup list is in a descending order

Correct answer: 1

Level: 4. expert

Pillar:

4237 - What’s the correct answer to the following statement:

You have a list of invoice numbers & amounts in a range A1:B100.
Some of the invoice numbers are duplicated.
You wrote VLOOKUP to find the amount corresponding to an invoice number.
If that invoice has 2 entries, then VLOOKUP will...

- VLOOKUP will always find the first match (assuming you specified FALSE in the last parameter).
- VLOOKUP will always find the second match.
- VLOOKUP will always find the first match (assuming you specified TRUE in the last parameter).
- VLOOKUP will find the no match.

Correct answer: 1

Level: 4. expert

Pillar:

4239 - Which of the following is the correct syntax for Hlookup?

- =HLOOKUP (value, table, [range_lookup])
- =HLOOKUP (Table, Value, row_index, [range_lookup])
- =HLOOKUP (value, table, row_index, [range_lookup])
- =HLOOKUP (value, table, Column_index, [range_lookup])

Correct answer: 3

Level: 4. expert

Pillar:

4241 - Which of the following answers is the correct syntax for Vlookup?

- =VLOOKUP (value, table, [range_lookup])
- =VLOOKUP (Value,Table, Column_index, [Approximate_Match])
- =VLOOKUP (Table,Value, Column_index, [Approximate_Match])
- =VLOOKUP (value, table, Column_index, [range_lookup])

Correct answer: 2

Level: 4. expert

Pillar:

4245 - MATCH function searches for a specified item in a range of cells, and then returns the _____ of that item in the range

- Relative Position
- Value that matches
- Both A and B
- None of the above

Correct answer: 1

Level: 4. expert

Pillar:

4267 - A gauge chart is combination of:

- Pie chart , Doughnut Chart
- 2 Pie charts
- Pie Chart and Bar Chart
- None of Above

Correct answer: 1

Level: 4. expert

Pillar:

4271 - What can you use to easily filter pivot tables interactively in a worksheet?

- Cutter
- Filter
- Slicer
- Division

Correct answer: 3

Level: 4. expert

Pillar:

4273 - What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

- Collapse/Expand
- Filter/Close Filter
- Subtract/Add
- None of the above

Correct answer: 1

Level: 4. expert

Pillar:

4275 - Mark wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

- Design
- Format
- Layout
- Analyze

Correct answer: 2

Level: 4. expert

Pillar:

4277 - In order to directly report the data, what must a PivotChart always be associated with?

- Pivot Table
- Table
- Chart
- Data

Correct answer: 1

Level: 4. expert

Pillar:

4279 - To allow users to apply various styles to the PivotTable, which tab on Excel ribbon is selected?

- Layout
- Format
- Design
- Analyze

Correct answer: 3

Level: 4. expert

Pillar:

4297 - What dialog box allows you to change a field name in a Pivot table?

- Content Field
- Field Options
- Field Operation
- Field Panel

Correct answer: 2

Level: 3. advanced

Pillar:

4299 - Which of the following is a box in the Pivot table fields List?

- Column labels
- Filter operation
- Text labels
- Content operation

Correct answer: 1

Level: 3. advanced

Pillar:

4301 - Which of the following is a way to provide a dynamic range in ‘data source’ of pivot tables?

- Create a Named range using Offset function
- Base the pivot table using the Named range created in Step 1
- None of the above
- Both A and B

Correct answer: 4

Level: 3. advanced

Pillar:

4303 - The return value of an If Statement is:

- True
- False
- None
- Either A or B

Correct answer: 4

Level: 3. advanced

Pillar:

4306 - Which of the following is the correct formula for the IF function in Excel?

- if(Logical_Test,Value_If_True,Value_If_False)
- =if(Logical_Test,Value_If_True,Value_If_False)
- None of the above
- Both A and B

Correct answer: 2

Level: 3. advanced

Pillar:

4308 - What do you need to include when you are entering text into your formula?

- ""
- ()
- []
- {}

Correct answer: 1

Level: 3. advanced

Pillar:

4310 - “COUNTIF” can be used to count values in cells containing:

- Text
- Numbers
- Dates
- all of the above

Correct answer: 4

Level: 3. advanced

Pillar:

4312 - COUNTIF takes following arguments:

- Range,Criteria
- Range only
- Criteria Only
- Range , Criteria ,True/False

Correct answer: 1

Level: 3. advanced

Pillar:

4314 - In Excel we can use ___ function to create data table

- Count
- Text
- Table
- Range

Correct answer: 3

Level: 4. expert

Pillar:

4316 - In Excel, 3-D reference in a formula

- Spans worksheets
- Can’t be modified
- Both A and B
- None of the above

Correct answer: 1

Level: 3. advanced

Pillar:

4318 - In Excel, which following feature can be used to work with one record at a time

- Auto correct
- Auto select
- Auto filter
- Data form

Correct answer: 4

Level: 3. advanced

Pillar:

4320 - If the value in cell B2 is 88, what will return the following IF statement?

=IF(B2>80, ''Pass'', ''Fail'')

- Fail
- Pass
- 80
- 88

Correct answer: 2

Level: 3. advanced

Pillar:

4329 - The syntax for the SUMIF function in Excel is:

- =SUMIF(criteria,range, [sum_range])
- =SUMIF(range,criteria,[sum_range])
- =SUMIF(criteria,[sum_range],range)
- =SUMIF([sum_range], criteria,range)

Correct answer: 2

Level: 4. expert

Pillar:

4331 - Which function will return TRUE value if multiple conditions are true?

- OR()
- AND()
- IF()
- All of the above

Correct answer: 2

Level: 4. expert

Pillar:

4333 - Pivot table is a powerful tool in excel that is use to:

- Calculate, summarize and analyze data
- Slice data
- Present data in charts
- Present data in tabular form

Correct answer: 1

Level: 3. advanced

Pillar:

4335 - To Select Field Names for Pivot table, which Pane is used:

- Pivot Tables Fields pane
- Pivot Tables Columns pane
- Pivot Tables Rows pane
- Pivot Tables Name pane

Correct answer: 1

Level: 4. expert

Pillar:

4337 - Pivot table is inserted:

- Above the first row
- Below the last row
- Next to the Last Column
- Depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.

Correct answer: 4

Level: 4. expert

Pillar:

4340 - We press ____ to activate the previous cell above in pre-selected range

- Alt+Tab
- Tab
- Keys Shift + Enter
- None of these

Correct answer: 3

Level: 4. expert

Pillar:

4342 - The COUNTIF function return incorrect value if you use it to match strings longer than:

- 250
- 255
- 200
- 155

Correct answer: 2

Level: 4. expert

Pillar:

4442 - Which is the formula syntax to get product of cell value at A1 and B1

- 3x8
- 3*8
- =3x8
- =A1*B1

Correct answer: 4

Level: 2. intermediate

Pillar:

4448 - Which formula will we use in Cell B6 to get the last day of the month?

- =EOMONTH($B2$,B6)
- =EOMONTH($B2$,A2)
- EOMONTH($B2$,C6)
- MONTH($B2$,B6)

Correct answer: 1

Level: 3. advanced

Pillar:

4452 - Looking at the following image, VLOOKUP will search in the cell F2 against the ID entered in E2 and will return?

- The name of the employee
- Rightmost value against the ID
- Leftmost value in the range
- 89

Correct answer: 1

Level: 3. advanced

Pillar:

4454 - Formula in cell A4 will return the result…

- 28 (Length including spaces)
- 23 (Length Excluding Spaces)
- 0
- 51

Correct answer: 1

Level: 3. advanced

Pillar:

4456 - Which formula is used to calculate age from a date in Cell A2

- =DATEDIF(A2,TODAY(),”y”)
- =DATEIF(A2,TODAY(),”y”)
- =AGE(A2,TODAY(),”y”)
- =DATEY(A2,TODAY(),”y”)

Correct answer: 1

Level: 4. expert

Pillar:

4458 - What will be the result of the formula in cell F6?

- 2
- Dell
- Printer
- None of above

Correct answer: 3

Level: 3. advanced

Pillar:

4460 - We can use ____ formula to get even round number

- ROUND(B5)
- =EVEN(B5)
- =EVENROUND(B5)
- =ROUND(B5,2)

Correct answer: 2

Level: 4. expert

Pillar:

4462 - In the following case, we can use ____ formula to get an ODD round result of B5

- ROUND(B5)
- =ODD(B5)
- =ODDROUND(B5)
- =ROUND(B5,2)

Correct answer: 2

Level: 1. beginner

Pillar:

4467 - Which chart is this?

- Pie Chart
- Doughnut Chart
- Bar Chart
- Radar Chart

Correct answer: 1

Level: 2. intermediate

Pillar:

4469 - For 2015, a company’s expected revenue was $12000. What is the correct formula syntax in cell C7, that will return the actual value generated, if the revenue is more than $12,000? If revenue is less than $12,000 it should return 0.

- =IF(A7>12000,C2,0)
- =IF(C2>12000,C2,0)
- =IF(C2<12000,C2,0)
- =IF(A7<12000,C2,0)

Correct answer: 2

Level: 2. intermediate

Pillar:

4474 - Assuming that cell B2 is displaying value 13000.712. Which formula is correct for rounding it to the closest integer number?

- =IROUND(B2,1)
- =ROUND(B2,0)
- ROUND(B2,10)
- ROUNDTO(B2,1)

Correct answer: 2

Level: 2. intermediate

Pillar:

4476 - What will happen if we drag formula $C2 to any other cell

- The row number will remain same
- The cell number will remain the same
- The column number remains the same
- Value remain the same

Correct answer: 3

Level: 3. advanced

Pillar:

4489 - Which formula can we use to remove spaces from a string?

- =STRING(A1,” “)
- =SUBSTITUTE(A1,” “,””)
- =STRINGSPACE(A1)
- =SPACE(A1,0)

Correct answer: 2

Level: 4. expert

Pillar:

4491 - Which formula is used to remove extra spaces in string value in cell A1? The result of the formula is shown in B1

- =SPACES(A1)
- =TRIM(A1)
- =STRINGSPACE(A1)
- =SPACE(A1,R)

Correct answer: 2

Level: 4. expert

Pillar:

4493 - To find the position of Employee entered in G3 we will use?

- =Position(B4;B11,”Richard”)
- =MATCH(B4:B11,0)
- =MATCH(G3,B4:B11,0)
- =POSITION(G3,B4;B11,”Richard”)

Correct answer: 3

Level: 3. advanced

Pillar:

4495 - Which formula is used to get the last day of next month when we give it the date shown in A1?

- =MONTH(A1,2)
- =EOMONTH(A1,2)
- =EOMONTH(A1,1)
- All of above are correct

Correct answer: 3

Level: 3. advanced

Pillar:

4497 - What formula can we use to get 10% Tax in cell B2?

- =A2*10%
- =A2*0.10
- =A2+(A2*10)
- A or B

Correct answer: 4

Level: 3. advanced

Pillar:

4499 - If the formula =VLOOKUP(E1,B2:C6,2,TRUE) is written in cell E2, what value will it return

- A
- E
- D
- C

Correct answer: 3

Level: 3. advanced

Pillar:

4501 - Which value the formula in the B2 cell will return?

- 3%
- 35%
- 45%
- None

Correct answer: 4

Level: 3. advanced

Pillar:

4503 - In the following picture we are looking into a potential project that will be acceptable if their IRR is above 20%. What formula will we use in C2 to C5 to show their results?

- =IF(B2>D2,"Accept","Reject")
- =IF(B2<D2,"Accept","Reject")
- Both A and B
- None of the above

Correct answer: 1

Level: 4. expert

Pillar:

4505 - What formula is correct to rank the values shown below?

- =ASCENDING(A2,A2;A7)
- =SORT(A2,A2;A7)
- =SORT(A2,$A2$;$A7$)
- =RANK(A2,$A2$;$A7$)

Correct answer: 4

Level: 4. expert

Pillar:

4507 - If the value in cell B1 is 80, what will the IF statement return?

- Fail
- Pass
- 80
- 88

Correct answer: 2

Level: 4. expert

Pillar:

4510 - Which formula can we use to calculate empty cells in the Value field?

- =if(B2:B7=””,Countcells)
- =if(B2:B7=”Empty”,Count)
- =COUNTBLANK(B2;B7)
- None of the above

Correct answer: 3

Level: 4. expert

Pillar:

4616 - To get the value 48 in A5 which formula is correct?

- =A1*A2*A3
- =A1xA2xA3
- A1*A2*A3
- =A1xA2xA3

Correct answer: 1

Level: 1. beginner

Pillar:

4618 - Formula in an Excel cell always starts with…

- ?
- *
- =
- #

Correct answer: 3

Level: 1. beginner

Pillar:

4620 - What is the correct syntax for cell reference in B1 to fix the multiplication with the list A1 to A6

- B*1
- B1
- *B1*
- $B$1

Correct answer: 4

Level: 1. beginner

Pillar:

4623 - To calculate the average score of all subjects, which formula is correct?

- =AVERAGE(B2:B4)
- =AVG(B2:B4)
- =AVERAGE(B2/B4)
- None of the above

Correct answer: 1

Level: 1. beginner

Pillar:

4625 - Which tab has the freeze-panes option if we want to freeze the top most row?

- Home
- Insert
- View
- Review

Correct answer: 3

Level: 1. beginner

Pillar:

4627 - Suppose we have a list of prices as shown below. What formula will you use to sum the Prices?

- =Sum(A1:A6)
- =A1+A6
- =Sum(A1-A6)
- =Add(A1-A6)

Correct answer: 1

Level: 1. beginner

Pillar:

4629 - If we select the transpose option after copying a row. What will happen?

- Row will be transposed to Column
- Row will be converted to another row
- No Change
- Column will be transposed to row

Correct answer: 1

Level: 1. beginner

Pillar:

4631 - If we select the transpose option after copying a Column. What will happen?

- Row will be transposed to Column
- Row will be converted to another row
- No Change
- Column will be transposed to row

Correct answer: 4

Level: 1. beginner

Pillar:

4633 - To add a comment on a cell, which option do we have to select from the menu below?

- Name a Range
- Format Cells
- Insert Comment
- Insert

Correct answer: 3

Level: 1. beginner

Pillar:

4635 - We have entered the value “Jan” in A1 cell. What value will we get if we drag cell A1 to A3?

- Jan , Jan , Jan
- Jan1,Jan2,Jan3
- Jan , Feb, Mar
- None of the above

Correct answer: 3

Level: 1. beginner

Pillar:

4637 - We have “Product 1” in A1 cell. What values will we get if we drag cell A1 to A3?

- Product 1 , Product 1 , Product 1
- Product 1 , Product 2, Product 3
- Product , Product , Product
- None of the above

Correct answer: 2

Level: 1. beginner

Pillar:

4640 - To Insert Pivot table Click the ______ tab?

- Home
- Insert
- View
- Page Layout

Correct answer: 2

Level: 2. intermediate

Pillar:

4642 - In the Create PivotTable window, Location is ______

- Worksheet Location
- Row Location
- Column Location
- Cell Location

Correct answer: 3

Level: 2. intermediate

Pillar:

4644 - In the following figure what will happen if we click the arrow in the Row Labels cell?

- It will Sort the Values in ascending order
- It will Sort the Values in descending order
- It will show the Filter values
- None of above

Correct answer: 3

Level: 2. intermediate

Pillar:

4646 - To get the items name of the pivot table in a row as shown, we will drag the item name field to…

- Column
- Row
- Filters
- None of above

Correct answer: 1

Level: 2. intermediate

Pillar: