Compubotics - Excel

Which of the following logical operations will  make A = 2 and B = 4 return a FALSE statement?

• A <= B

• A >= B

• A <> B

• 2*A = B

If you wanted to lock Cell A10’s column in further calculations how would you reference it in the formula?

• Type A10

• Type $A$10

• Type $A10

• Type A$10

If you wanted to lock Cell A10’s row in further calculations how would you reference it in the formula?

• Type A10

• Type $A$10

• Type $A10

• Type A$10

When starting from the top of a table, what is the shortcut to select all the values along a column?

• CTRL+SHIFT+R

• CTRL+SHIFT+L

• CTRL+SHIFT+D

                

• CTRL+SHIFT+U

Which of the following is NOT an Excel wildcard for working with strings?

• Asterisk (*)

•    Question mark (?)

• Ampersand (&)

• Tilde (~)

Which of the following data types can be counted using COUNT?

• Blanks

• Dates

• Strings

• Numbers

Which of the following is not a piece of information you need to provide to use VLOOKUP?

• The lookup value

• The range of cells

• The number of the column to retrieve the result from

•    The data type of the value

Which of the following is the main advantage of using IFS over IF?

• Avoids nested IF statements

• To perform logical tests on data

• To show when one result when the logical test is true and a different result when it is false

• Please I don't know the answer

When would you use SUMIFS exclusively instead of SUMIF?

•                                  When you want to sum cells that meet multiple criteria

• When you want to sum cells that meet one criteria

• When you want to find the sum across multiple cells

• When you want to impress your boss

Which of the following is not what a Pivot Table is used for?

• Querying a large amount of data

• Analyzing quantitative data

• Rearranging a dataset without modifying the original data

• Updating new data in a dataset