Excel Essentials Quiz

Which of the following is not the purpose of using a spreadsheet software like Microsoft Excel?

• To perform calculation

• To conduct data analysis

• To design a poster

• To create automation process

A book contains many pages. In Microsoft Excel, what is considered as the book and what is considered as the pages?

• Worksheet; Workbook

• Workbook, Worksheet

• Workbook, Tab

• Worksheet, Tab

Alia has been using the function & in her data cleaning process for as long as she remembers. However, recently she has been having problem to combine multiple sentences from multiple columns since each sentences has specific condition to fulfil. She searched the web and found out about a new function in Excel called TEXTJOIN. Alia is demonstrating which principle when it comes to building an Excel mindset?

• Approaching data structurally

• Breaking down problems into smaller tasks

• Continuous learning

• Being resourceful and smart

Which formula converts text in a cell to all uppercase letters?

• PROPER

• UPPER

• LOWER

• CAPITAL

In cell A2 the data is Chicago. In cell B2 the data is Illinois. In cell C2, the data is US. You typed the following formula into cell D2: =B2&"-"&C2

What will be generated in cell D2?

• Chicago-Illinois

• Chicago Illinois

• Illinois-US

• Chicago-US

What should you do if using a formula creates a #REF! error after deleting a column?

• Restart Excel

• Ignore the error

• Copy and use Paste Values

• Use the LOWER formula

The following is the hierarchy in a company.

Associate Consultant > Senior Consultant > Principle Consultant > Partner

How do you ensure when sorting by Position, this order is followed?

• Sort by oldest to newest

• Sort by highest to lowest

• Sort by order list

• Sort from A to Z

In your workbook, after inputting a formula, the following error is shown:

The range can't be found.

Which of the following might it refers to?

• C15:G17

• #REF!

• C12

• =ROMAN(D2)

What is the reason of using Custom Number Format to input units such as kg and cm, instead of inputting the unit in each row?

• It might interfere with calculation

• It doesn't look good

• It looks messy

• It's too much work

How do you fix this error?

• Retype the log time again

• Use TIME formula

• Change the Number Format

• Use Custom Sort