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
Correct answer: 4
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
Correct answer: 4
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
Correct answer: 2
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
Correct answer: 3
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
Correct answer: 2
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
Correct answer: 1
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
Correct answer: 1
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
Correct answer: 1
Level: 1. beginner
Category: Labels
Pillar:
4118 - Which term best refers to an Excel File?
  1. E-File
  2. Word File
  3. Spreadsheet
  4. Workbook
Correct answer: 4
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
Correct answer: 1
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
Correct answer: 3
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
Correct answer: 3
Level: 1. beginner
Category: Excel Basics
Pillar:
4129 - Which terminology is not used in MS-Excel?
  1. Worksheet
  2. Cells
  3. Columns
  4. Slide
Correct answer: 4
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
Correct answer: 4
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
Correct answer: 1
Level: 1. beginner
Category: Shortcut keys
Pillar:
4139 - Which option represents the Cell address:
  1. 5 2
  2. E2
  3. 25
  4. 2E
Correct answer: 2
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
Correct answer: 1
Level: 2. intermediate
Category: Date Function
Pillar:
4144 - Every function of Excel must start with ____
  1. A less-than sign (<)
  2. A minus sign (-)
  3. A parentesis ()
  4. None of the above
Correct answer: 3
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
Correct answer: 3
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
Correct answer: 1
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
Correct answer: 3
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
Correct answer: 1
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
Correct answer: 3
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
Correct answer: 3
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
Correct answer: 1
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
Correct answer: 4
Level: 2. intermediate
Category: Condition operations
Pillar:
4170 - Which operation will you perform to lock the data in your cells from being edited?
  1. Password protect sheet
  2. Freeze panes
  3. Conditional formatting
  4. None of the above
Correct answer: 1
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
Correct answer: 4
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
  3. Use advanced criteria filter
  4. Any of the above
Correct answer: 3
Level: 2. intermediate
Category: Menu operations
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
Correct answer: 3
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
Correct answer: 3
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
Correct answer: 2
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
Correct answer: 3
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)
Correct answer: 4
Level: 3. advanced
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))
Correct answer: 4
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 1
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
Category: Match
Pillar:
4207 - MATCH returns the position of the matched value within
  1. lookup_Row
  2. lookup_array
  3. Column
  4. Row
Correct answer: 2
Level: 3. advanced
Category: Match
Pillar:
4211 - When using an Array Formula, you press:
  1. Ctrl+Shift+Enter
  2. Enter
  3. Ctrl+Shift
  4. None of above
Correct answer: 1
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 3
Level: 3. advanced
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
Correct answer: 3
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
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
Correct answer: 3
Level: 3. advanced
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
Correct answer: 1
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.
Correct answer: 1
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])
Correct answer: 3
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])
Correct answer: 2
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
Correct answer: 1
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
Correct answer: 1
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
Correct answer: 3
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
  3. Subtract/Add
  4. None of the above
Correct answer: 1
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
Correct answer: 2
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
Correct answer: 1
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
Correct answer: 3
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
Correct answer: 2
Level: 3. advanced
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
Correct answer: 1
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
Category: Pivot Table
Pillar:
4303 - The return value of an If Statement is:
  1. True
  2. False
  3. None
  4. Either A or B
Correct answer: 4
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
Category: If Statement
Pillar:
4308 - What do you need to include when you are entering text into your formula?
  1. ""
  2. ()
  3. []
  4. {}
Correct answer: 1
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
Category: If Statement
Pillar:
4312 - COUNTIF takes following arguments:
  1. Range,Criteria
  2. Range only
  3. Criteria Only
  4. Range , Criteria ,True/False
Correct answer: 1
Level: 3. advanced
Category: If Statement
Pillar:
4314 - In Excel we can use ___ function to create data table
  1. Count
  2. Text
  3. Table
  4. Range
Correct answer: 3
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
Correct answer: 1
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
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
Correct answer: 2
Level: 3. advanced
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)
Correct answer: 2
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
Correct answer: 2
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
Correct answer: 1
Level: 3. advanced
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
Correct answer: 1
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.
Correct answer: 4
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
Correct answer: 3
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
Correct answer: 2
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
Correct answer: 4
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)
Correct answer: 1
Level: 3. advanced
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
Correct answer: 1
Level: 3. advanced
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
Correct answer: 1
Level: 3. advanced
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”)
Correct answer: 1
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
Correct answer: 3
Level: 3. advanced
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)
Correct answer: 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)
Correct answer: 2
Level: 1. beginner
Category: Excel Basics
Pillar:
4467 - Which chart is this?
  1. Pie Chart
  2. Doughnut Chart
  3. Bar Chart
  4. Radar Chart
Correct answer: 1
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)
Correct answer: 2
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)
Correct answer: 2
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
Correct answer: 3
Level: 3. advanced
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)
Correct answer: 2
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)
Correct answer: 2
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”)
Correct answer: 3
Level: 3. advanced
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
Correct answer: 3
Level: 3. advanced
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
Correct answer: 4
Level: 3. advanced
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
Correct answer: 3
Level: 3. advanced
Category: Vlookup
Pillar:
4501 - Which value the formula in the B2 cell will return?
  1. 3%
  2. 35%
  3. 45%
  4. None
Correct answer: 4
Level: 3. advanced
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
Correct answer: 1
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$)
Correct answer: 4
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
Correct answer: 2
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
Correct answer: 3
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
Correct answer: 1
Level: 1. beginner
Category: Formulas
Pillar:
4618 - Formula in an Excel cell always starts with…
  1. ?
  2. *
  3. =
  4. #
Correct answer: 3
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
Correct answer: 4
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
Correct answer: 1
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
Correct answer: 3
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)
  4. =Add(A1-A6)
Correct answer: 1
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
Correct answer: 1
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
Correct answer: 4
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
Correct answer: 3
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
Correct answer: 3
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
Correct answer: 2
Level: 1. beginner
Category: Excel Basics
Pillar:
4640 - To Insert Pivot table Click the ______ tab?
  1. Home
  2. Insert
  3. View
  4. Page Layout
Correct answer: 2
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
Correct answer: 3
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
Correct answer: 3
Level: 2. intermediate
Category: Pivot Table
Pillar:
4646 - To get the items name of the pivot table in a row as shown, we will drag the item name field to…
  1. Column
  2. Row
  3. Filters
  4. None of above
Correct answer: 1
Level: 2. intermediate
Category: Pivot Table
Pillar: