## Réviser les assessments

Total: 116 questions
4093 - On an Excel Spreadsheet, what is the intersection of a row and a column called?
1. Row
2. Column
3. Value
4. Cell
Level: 1. beginner
Category: Excel Basics
Pillar:

4095 - Which Excel function calculates the numbers of entries in cells that are in the number format?
1. Sum
2. Average
3. Both A & B
4. Count
Level: 1. beginner
Category: Arithmetic Operation
Pillar:

4097 - Which Excel chart is best suited to display percentages represented by category?
1. Column Chart
2. Pie Chart
3. Line Chart
4. None of the Above
Level: 1. beginner
Category: Charts
Pillar:

4099 - Which feature in Excel arranges the list of names in a column in an alphabetical manner?
1. Filtering
2. Format
3. Sort
4. Pivot
Level: 1. beginner
Category: Excel Operations
Pillar:

4101 - In Excel, what does A1 reference style represent?
1. A refers to the row as letter and 1 refers to the column number
2. A refers to the column as letter and 1 refers to the row number
3. None of the above
4. Both A and B
Level: 1. beginner
Category: Referencing style
Pillar:

4104 - To calculate the largest value in a given list of numeric values, which Excel function will be used?
1. MAX
2. MIN
3. SUM
4. COUNT
Level: 1. beginner
Category: Statistical function
Pillar:

4112 - Which tab on the Excel Menu Bar is selected to create a chart?
1. Chart Wizard
2. Number Wizard
3. Cells Wizard
4. Excel Wizard
Level: 1. beginner
Category: Ribbon
Pillar:

4114 - When we create a new Excel file, what is the default sheet labelled as?
1. Sheet1
2. Blank
3. Excel
4. Dummy
Level: 1. beginner
Category: Labels
Pillar:

4118 - Which term best refers to an Excel File?
1. E-File
2. Word File
4. Workbook
Level: 1. beginner
Category: Excel Files
Pillar:

4120 - How can you add number values in a range quickly in Excel?
1. Use the Sum Function
2. Individually select each cell value and then Sum it manually
3. Use the MAX function
4. None of the Above
Level: 1. beginner
Category: Arithmetic operations
Pillar:

4122 - What is the shortcut key to undo an operation in Excel?
1. CTRL+C
2. CTRL+V
3. CTRL+Z
4. Shift+P
Level: 1. beginner
Category: Shortcut key operations
Pillar:

4127 - What is Format Painter used for?
1. It copies data from one cell to another
2. It deletes the value in a cell
3. It copies format from a cell and applies it on another cell
4. None of the above
Level: 1. beginner
Category: Excel Basics
Pillar:

4129 - Which terminology is not used in MS-Excel?
1. Worksheet
2. Cells
3. Columns
4. Slide
Level: 1. beginner
Category: Excel Basics
Pillar:

4131 - Which of the following is not an Excel Function?
1. COUNT
2. MAX
3. SUM
4. AVG
Level: 1. beginner
Category: Functions
Pillar:

4133 - If you want to Bold value(s) in a cell or multiple cells, which command will you execute?
1. CTRL+B
2. CTRL+A
3. CTRL+C
4. CTRL+V
Level: 1. beginner
Category: Shortcut keys
Pillar:

4139 - Which option represents the Cell address:
1. 5 2
2. E2
3. 25
4. 2E
Level: 1. beginner
Category: Excel Basics
Pillar:

4142 - Which Excel Function will take date as an input and return a number to represent the day of the week?
1. WEEKDAY
2. DATE
3. YEAR
4. WORKDAY
Level: 2. intermediate
Category: Date Function
Pillar:

1. A less-than sign (<)
2. A minus sign (-)
3. A parentesis ()
4. None of the above
Level: 2. intermediate
Category: Functions
Pillar:

4148 - Which function of Excel will get the serial number of today’s date?
1. TIME
2. NOW
3. TODAY
4. DATE
Level: 2. intermediate
Category: Date Functions
Pillar:

4150 - If you automatically want to highlight numbers greater than 100 in Yellow color, which operation will you perform?
1. Conditional Formatting
2. Format Painter
3. Filter
4. Merge and Center
Level: 2. intermediate
Category: Conditional Operations
Pillar:

4154 - What operation does the CONCATENATE function perform?
1. It adds number values from multiple cells
2. It averages number values from multiple cells
3. It combines text or number values from multiple cells
4. It split a single text value into multiple cells
Level: 2. intermediate
Category: Functions
Pillar:

4156 - What Excel function is used to calculate the length of the text string in a cell?
1. LEN
2. RIGHT
3. LEFT
4. MID
Level: 2. intermediate
Category: Functions
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?
1. Edit As
2. Save
3. Save As
4. This functionality is not possible in Excel
Level: 2. intermediate
Category: Excel Basics
Pillar:

4164 - What will happen if rows 3 and 4 are selected and then we right-click and Select “Insert “ option?
1. Two Rows will be inserted after Row 4
2. Two Rows will be inserted after Row 3
3. Two Rows will be inserted before Row 3
4. Two Rows will be inserted before Row 4
Level: 2. intermediate
Category: Row operations
Pillar:

4166 - What will happen if Column A and B are selected and then we right-click and Select “Insert“ option?
1. Two Columns will be inserted before Column A
2. Two Columns will be inserted After Column A
3. Two Columns will be inserted before Column B
4. Two Columns will be inserted after Column B
Level: 2. intermediate
Category: Column Operations
Pillar:

4168 - Which of the following is true for Conditional formatting?
1. Find bold values and apply italics
2. More than one condition can be implemented in a worksheet
3. You can change color of a cell if a specified condition is met
4. Both B and C
Level: 2. intermediate
Category: Condition operations
Pillar:

4170 - Which operation will you perform to lock the data in your cells from being edited?
2. Freeze panes
3. Conditional formatting
4. None of the above
Level: 2. intermediate
Category: Excel Operations
Pillar:

4172 - Which excel function is used to count cells that match a certain criteria?
1. Count
2. CountA
3. CountBlank
4. CountIF and CountIFS
Level: 2. intermediate
Category: Functions
Pillar:

4174 - If you want to filter values based on two or more conditions what operations will you perform?
1. Filter and apply conditional formatting
2. Filter and sort
4. Any of the above
Level: 2. intermediate
Pillar:

4177 - For example, \$C\$12 is the cell address. What does the \$ sign represent?
1. The column address will remain constant
2. The row address will remain constant
3. Both the column and the row address will remain constant
4. It doesn’t signifies anything
Level: 2. intermediate
Category: Functions
Pillar:

4179 - What will this return the following:
=SUMIF (E1: G1,”<10)
1. It will return the Sum of cell values from E1 to G1
2. It will return the Sum of cell values that are equal to 10
3. It will return the Sum of cell values which are less than 10
4. It will return the Sum of cell values which are greater than 10
Level: 2. intermediate
Category: Functions
Pillar:

4183 - Which function is used to calculate the sum of values based on some condition?
1. SUM
2. SUMIF
3. COUNTIF
4. SUMPRODUCT
Level: 2. intermediate
Category: Functions
Pillar:

4185 - Which is incorrect for a VLOOKUP function of Excel?
1. It is a built-in function
2. It’s a vertical lookup function
3. The algorithm of vlookup explorers the value from the rightmost column
4. The algorithm of vlookup explorers the value from the leftmost column
Level: 2. intermediate
Category: Functions
Pillar:

4187 - Which of the following would result in a #REF error?
1. =INDEX(A2:D8, 1, 2)
2. =INDEX(A2:D2, 2)
3. =INDEX(A2:A8, 1, 1)
4. =INDEX(A2:B8, 1, 5)
Category: Index
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?
1. =INDEX(A3:D7, MATCH(“Won”, A3:D7, 4), 1)
2. =INDEX(A3:D7, MATCH(“Won”, D3:D7))
3. =MATCH(D3:D7, INDEX(“Won”, A3:A7)
4. =INDEX(A3:A7, MATCH(“Won”, D3:D7, 0))
Category: Index
Pillar:

4193 - If the value you are looking up is not found, VLOOKUP will return
1. #VALUE!
2. #N/A
3. No Value
4. #error
Category: Vlookup
Pillar:

4195 - To find the best results in an approximate match through VLOOKUP we have to sort the data by which order?
1. Descending
2. Ascending
3. Both
4. Neither
Category: Vlookup
Pillar:

4197 - Which lookup function is used to search value in the row?
1. HLOOKUP
2. VLOOKUP
3. Both can search in row
4. None
Category: Hlookup
Pillar:

4199 - Which lookup function is used to search value in the Column?
1. Hlookup
2. Vlookup
3. Both can search in row
4. None
Category: Vlookup
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)
1. 35
2. 2
3. 3
4. 0
Category: Match
Pillar:

4205 - The MATCH function syntax has the following arguments:
1. Lookup Value
2. Lookup Array
3. Match Type
4. All of above
Category: Match
Pillar:

4207 - MATCH returns the position of the matched value within
1. lookup_Row
2. lookup_array
3. Column
4. Row
Category: Match
Pillar:

4211 - When using an Array Formula, you press:
1. Ctrl+Shift+Enter
2. Enter
3. Ctrl+Shift
4. None of above
Category: Arrays
Pillar:

4213 - An Array Formula will show ______ around the formula in the Formula Bar
1. Square brackets
2. Curly brackets
3. This formula is without brackets
4. All of above
Category: Arrays
Pillar:

4215 - Which of the following chart is suitable for comparing multiple categories and data series:
1. Line chart
2. Column chart
3. Stacked column chart
4. Bar chart
Category: Charts
Pillar:

4217 - Cons of Stacked chart are:
1. Difficult to compare all but first series
2. Become visually complex as categories or series are added
3. A and B
4. Can show change over time
Category: Charts
Pillar:

4219 - Pros of Stacked chart are:
1. Can show change over time
2. Difficult to compare all but first series
3. Multiple categories and data series in compact space
4. A and C
Category: Charts
Pillar:

4231 - When the user clicks a button, _________ is triggered
1. A Method
2. A setting
3. An Event
4. None of the above
Category: Excel VBA
Pillar:

4235 - When would you use FALSE as 4th parameter in VLOOKUP?
1. When lookup list is not in any particular sort order
2. When lookup list is in any particular sort order
3. When lookup list is in an ascending order
4. when lookup list is in a descending order
Level: 4. expert
Category: Vlookup
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...
1. VLOOKUP will always find the first match (assuming you specified FALSE in the last parameter).
2. VLOOKUP will always find the second match.
3. VLOOKUP will always find the first match (assuming you specified TRUE in the last parameter).
4. VLOOKUP will find the no match.
Level: 4. expert
Category: Vlookup
Pillar:

4239 - Which of the following is the correct syntax for Hlookup?
1. =HLOOKUP (value, table, [range_lookup])
2. =HLOOKUP (Table, Value, row_index, [range_lookup])
3. =HLOOKUP (value, table, row_index, [range_lookup])
4. =HLOOKUP (value, table, Column_index, [range_lookup])
Level: 4. expert
Category: Hlookup
Pillar:

4241 - Which of the following answers is the correct syntax for Vlookup?
1. =VLOOKUP (value, table, [range_lookup])
2. =VLOOKUP (Value,Table, Column_index, [Approximate_Match])
3. =VLOOKUP (Table,Value, Column_index, [Approximate_Match])
4. =VLOOKUP (value, table, Column_index, [range_lookup])
Level: 4. expert
Category: Vlookup
Pillar:

4245 - MATCH function searches for a specified item in a range of cells, and then returns the _____ of that item in the range
1. Relative Position
2. Value that matches
3. Both A and B
4. None of the above
Level: 4. expert
Category: Match
Pillar:

4267 - A gauge chart is combination of:
1. Pie chart , Doughnut Chart
2. 2 Pie charts
3. Pie Chart and Bar Chart
4. None of Above
Level: 4. expert
Category: Charts
Pillar:

4271 - What can you use to easily filter pivot tables interactively in a worksheet?
1. Cutter
2. Filter
3. Slicer
4. Division
Level: 4. expert
Category: Pivot Table
Pillar:

4273 - What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
1. Collapse/Expand
2. Filter/Close Filter
4. None of the above
Level: 4. expert
Category: Pivot Table
Pillar:

4275 - Mark wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
1. Design
2. Format
3. Layout
4. Analyze
Level: 4. expert
Category: Pivot Table
Pillar:

4277 - In order to directly report the data, what must a PivotChart always be associated with?
1. Pivot Table
2. Table
3. Chart
4. Data
Level: 4. expert
Category: Pivot Table
Pillar:

4279 - To allow users to apply various styles to the PivotTable, which tab on Excel ribbon is selected?
1. Layout
2. Format
3. Design
4. Analyze
Level: 4. expert
Category: Pivot Table
Pillar:

4297 - What dialog box allows you to change a field name in a Pivot table?
1. Content Field
2. Field Options
3. Field Operation
4. Field Panel
Category: Pivot Table
Pillar:

4299 - Which of the following is a box in the Pivot table fields List?
1. Column labels
2. Filter operation
3. Text labels
4. Content operation
Category: Pivot Table
Pillar:

4301 - Which of the following is a way to 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. None of the above
4. Both A and B
Category: Pivot Table
Pillar:

4303 - The return value of an If Statement is:
1. True
2. False
3. None
4. Either A or B
Category: If Statement
Pillar:

4306 - Which of the following is the correct formula for the IF function in Excel?
1. if(Logical_Test,Value_If_True,Value_If_False)
2. =if(Logical_Test,Value_If_True,Value_If_False)
3. None of the above
4. Both A and B
Category: If Statement
Pillar:

4308 - What do you need to include when you are entering text into your formula?
1. ""
2. ()
3. []
4. {}
Category: If Statement
Pillar:

4310 - “COUNTIF” can be used to count values in cells containing:
1. Text
2. Numbers
3. Dates
4. all of the above
Category: If Statement
Pillar:

4312 - COUNTIF takes following arguments:
1. Range,Criteria
2. Range only
3. Criteria Only
4. Range , Criteria ,True/False
Category: If Statement
Pillar:

4314 - In Excel we can use ___ function to create data table
1. Count
2. Text
3. Table
4. Range
Level: 4. expert
Category: Excel Basics
Pillar:

4316 - In Excel, 3-D reference in a formula
1. Spans worksheets
2. Can’t be modified
3. Both A and B
4. None of the above
Category: Excel Basics
Pillar:

4318 - In Excel, which following feature can be used to work with one record at a time
1. Auto correct
2. Auto select
3. Auto filter
4. Data form
Category: Excel Basics
Pillar:

4320 - If the value in cell B2 is 88, what will return the following IF statement?
=IF(B2>80, ''Pass'', ''Fail'')
1. Fail
2. Pass
3. 80
4. 88
Category: Logical Statements
Pillar:

4329 - The syntax for the SUMIF function in Excel is:
1. =SUMIF(criteria,range, [sum_range])
2. =SUMIF(range,criteria,[sum_range])
3. =SUMIF(criteria,[sum_range],range)
4. =SUMIF([sum_range], criteria,range)
Level: 4. expert
Category: Logical Statements
Pillar:

4331 - Which function will return TRUE value if multiple conditions are true?
1. OR()
2. AND()
3. IF()
4. All of the above
Level: 4. expert
Category: Logical Statements
Pillar:

4333 - Pivot table is a powerful tool in excel that is use to:
1. Calculate, summarize and analyze data
2. Slice data
3. Present data in charts
4. Present data in tabular form
Category: Pivot Table
Pillar:

4335 - To Select Field Names for Pivot table, which Pane is used:
1. Pivot Tables Fields pane
2. Pivot Tables Columns pane
3. Pivot Tables Rows pane
4. Pivot Tables Name pane
Level: 4. expert
Category: Pivot Table
Pillar:

4337 - Pivot table is inserted:
1. Above the first row
2. Below the last row
3. Next to the Last Column
4. Depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
Level: 4. expert
Category: Pivot Table
Pillar:

4340 - We press ____ to activate the previous cell above in pre-selected range
1. Alt+Tab
2. Tab
3. Keys Shift + Enter
4. None of these
Level: 4. expert
Category: Excel Basics
Pillar:

4342 - The COUNTIF function return incorrect value if you use it to match strings longer than:
1. 250
2. 255
3. 200
4. 155
Level: 4. expert
Category: Functions
Pillar:

4442 - Which is the formula syntax to get product of cell value at A1 and B1
1. 3x8
2. 3*8
3. =3x8
4. =A1*B1
Level: 2. intermediate
Category: Excel Basics
Pillar:

4448 - Which formula will we use in Cell B6 to get the last day of the month?
1. =EOMONTH(\$B2\$,B6)
2. =EOMONTH(\$B2\$,A2)
3. EOMONTH(\$B2\$,C6)
4. MONTH(\$B2\$,B6)
Category: Excel Basics
Pillar:

4452 - Looking at the following image, VLOOKUP will search in the cell F2 against the ID entered in E2 and will return?
1. The name of the employee
2. Rightmost value against the ID
3. Leftmost value in the range
4. 89
Category: Vlookup
Pillar:

4454 - Formula in cell A4 will return the result…
1. 28 (Length including spaces)
2. 23 (Length Excluding Spaces)
3. 0
4. 51
Category: Excel Basics
Pillar:

4456 - Which formula is used to calculate age from a date in Cell A2
1. =DATEDIF(A2,TODAY(),”y”)
2. =DATEIF(A2,TODAY(),”y”)
3. =AGE(A2,TODAY(),”y”)
4. =DATEY(A2,TODAY(),”y”)
Level: 4. expert
Category: Excel Basics
Pillar:

4458 - What will be the result of the formula in cell F6?
1. 2
2. Dell
3. Printer
4. None of above
Category: Excel Basics
Pillar:

4460 - We can use ____ formula to get even round number
1. ROUND(B5)
2. =EVEN(B5)
3. =EVENROUND(B5)
4. =ROUND(B5,2)
Level: 4. expert
Category: Excel Basics
Pillar:

4462 - In the following case, we can use ____ formula to get an ODD round result of B5
1. ROUND(B5)
2. =ODD(B5)
3. =ODDROUND(B5)
4. =ROUND(B5,2)
Level: 1. beginner
Category: Excel Basics
Pillar:

4467 - Which chart is this?
1. Pie Chart
2. Doughnut Chart
3. Bar Chart
Level: 2. intermediate
Category: Charts
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.
1. =IF(A7>12000,C2,0)
2. =IF(C2>12000,C2,0)
3. =IF(C2<12000,C2,0)
4. =IF(A7<12000,C2,0)
Level: 2. intermediate
Category: If Statement
Pillar:

4474 - Assuming that cell B2 is displaying value 13000.712. Which formula is correct for rounding it to the closest integer number?
1. =IROUND(B2,1)
2. =ROUND(B2,0)
3. ROUND(B2,10)
4. ROUNDTO(B2,1)
Level: 2. intermediate
Category: Formulas
Pillar:

4476 - What will happen if we drag formula \$C2 to any other cell
1. The row number will remain same
2. The cell number will remain the same
3. The column number remains the same
4. Value remain the same
Category: Excel Basics
Pillar:

4489 - Which formula can we use to remove spaces from a string?
1. =STRING(A1,” “)
2. =SUBSTITUTE(A1,” “,””)
3. =STRINGSPACE(A1)
4. =SPACE(A1,0)
Level: 4. expert
Category: Formulas
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
1. =SPACES(A1)
2. =TRIM(A1)
3. =STRINGSPACE(A1)
4. =SPACE(A1,R)
Level: 4. expert
Category: Formulas
Pillar:

4493 - To find the position of Employee entered in G3 we will use?
1. =Position(B4;B11,”Richard”)
2. =MATCH(B4:B11,0)
3. =MATCH(G3,B4:B11,0)
4. =POSITION(G3,B4;B11,”Richard”)
Category: Match/Index
Pillar:

4495 - Which formula is used to get the last day of next month when we give it the date shown in A1?
1. =MONTH(A1,2)
2. =EOMONTH(A1,2)
3. =EOMONTH(A1,1)
4. All of above are correct
Category: Time Functions
Pillar:

4497 - What formula can we use to get 10% Tax in cell B2?
1. =A2*10%
2. =A2*0.10
3. =A2+(A2*10)
4. A or B
Category: Formulas
Pillar:

4499 - If the formula =VLOOKUP(E1,B2:C6,2,TRUE) is written in cell E2, what value will it return
1. A
2. E
3. D
4. C
Category: Vlookup
Pillar:

4501 - Which value the formula in the B2 cell will return?
1. 3%
2. 35%
3. 45%
4. None
Category: Vlookup
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?
1. =IF(B2>D2,"Accept","Reject")
2. =IF(B2<D2,"Accept","Reject")
3. Both A and B
4. None of the above
Level: 4. expert
Category: Vlookup
Pillar:

4505 - What formula is correct to rank the values shown below?
1. =ASCENDING(A2,A2;A7)
2. =SORT(A2,A2;A7)
3. =SORT(A2,\$A2\$;\$A7\$)
4. =RANK(A2,\$A2\$;\$A7\$)
Level: 4. expert
Category: Formulas
Pillar:

4507 - If the value in cell B1 is 80, what will the IF statement return?
1. Fail
2. Pass
3. 80
4. 88
Level: 4. expert
Category: Logical Statements
Pillar:

4510 - Which formula can we use to calculate empty cells in the Value field?
1. =if(B2:B7=””,Countcells)
2. =if(B2:B7=”Empty”,Count)
3. =COUNTBLANK(B2;B7)
4. None of the above
Level: 4. expert
Category: Formulas
Pillar:

4616 - To get the value 48 in A5 which formula is correct?
1. =A1*A2*A3
2. =A1xA2xA3
3. A1*A2*A3
4. =A1xA2xA3
Level: 1. beginner
Category: Formulas
Pillar:

4618 - Formula in an Excel cell always starts with…
1. ?
2. *
3. =
4. #
Level: 1. beginner
Category: Formulas
Pillar:

4620 - What is the correct syntax for cell reference in B1 to fix the multiplication with the list A1 to A6
1. B*1
2. B1
3. *B1*
4. \$B\$1
Level: 1. beginner
Category: Formulas
Pillar:

4623 - To calculate the average score of all subjects, which formula is correct?
1. =AVERAGE(B2:B4)
2. =AVG(B2:B4)
3. =AVERAGE(B2/B4)
4. None of the above
Level: 1. beginner
Category: Excel Basics
Pillar:

4625 - Which tab has the freeze-panes option if we want to freeze the top most row?
1. Home
2. Insert
3. View
4. Review
Level: 1. beginner
Category: Excel Basics
Pillar:

4627 - Suppose we have a list of prices as shown below. What formula will you use to sum the Prices?
1. =Sum(A1:A6)
2. =A1+A6
3. =Sum(A1-A6)
Level: 1. beginner
Category: Formulas
Pillar:

4629 - If we select the transpose option after copying a row. What will happen?
1. Row will be transposed to Column
2. Row will be converted to another row
3. No Change
4. Column will be transposed to row
Level: 1. beginner
Category: Excel Basics
Pillar:

4631 - If we select the transpose option after copying a Column. What will happen?
1. Row will be transposed to Column
2. Row will be converted to another row
3. No Change
4. Column will be transposed to row
Level: 1. beginner
Category: Excel Basics
Pillar:

4633 - To add a comment on a cell, which option do we have to select from the menu below?
1. Name a Range
2. Format Cells
3. Insert Comment
4. Insert
Level: 1. beginner
Category: Excel Basics
Pillar:

4635 - We have entered the value “Jan” in A1 cell. What value will we get if we drag cell A1 to A3?
1. Jan , Jan , Jan
2. Jan1,Jan2,Jan3
3. Jan , Feb, Mar
4. None of the above
Level: 1. beginner
Category: Excel Basics
Pillar:

4637 - We have “Product 1” in A1 cell. What values will we get if we drag cell A1 to A3?
1. Product 1 , Product 1 , Product 1
2. Product 1 , Product 2, Product 3
3. Product , Product , Product
4. None of the above
Level: 1. beginner
Category: Excel Basics
Pillar:

4640 - To Insert Pivot table Click the ______ tab?
1. Home
2. Insert
3. View
4. Page Layout
Level: 2. intermediate
Category: Pivot Table
Pillar:

4642 - In the Create PivotTable window, Location is ______
1. Worksheet Location
2. Row Location
3. Column Location
4. Cell Location
Level: 2. intermediate
Category: Pivot Table
Pillar:

4644 - In the following figure what will happen if we click the arrow in the Row Labels cell?
1. It will Sort the Values in ascending order
2. It will Sort the Values in descending order
3. It will show the Filter values
4. None of above