Excel

Question 1

What is the Microsoft Excel term for where the name of a worksheet and the application name are listed?

Answer 1

The title bar.

Question 2

What is the term in Excel for the customizable toolbar that provides quick access to frequently used commands?

Answer 2

Quick Access Toolbar

Question 3

Where can one find the ribbon display options?

Answer 3

Next to minimize, restore / maximize and close buttons.

Question 4

How many rows are supplied in Excel by default?

Answer 4

Over a million.

Question 5

How many columns are supplied in an Excel worksheet by default?

Answer 5

About 16,000.

Question 6

In Excel, where a row and a column intersect is called a …

Answer 6

cell.

Question 7

You can edit information or formulas stored within a cell by clicking on the UI element in Excel called …

Answer 7

the formula bar.

Question 8

The default name for a worksheet in Excel is …

Answer 8

Sheet1.

Question 9

What is the difference between a workbook and a worksheet in Excel?

Answer 9

A workbook holds one or many worksheets.

Question 10

What is the keyboard shortcut to go to cell A1 in Excel?

Answer 10

Control/Command Home -> A1

Question 11

What is the keyboard shortcut to go to the last cell with information in Excel?

Answer 11

Control/Command End -> Last

Question 12

What is the keyboard shortcut to go to the cell to the right of the currently selected cell in Excel?

Answer 12

Tab.

Question 13

What is the keyboard shortcut for goto in Excel?

Answer 13

F5 / Control/Command G -> Go to

Question 14

In Excel, the text cursor blinks in Excel in the formula bar at …

Answer 14

the insertion point.

Question 15

What was the first way to open up the format cells option in Excel?

Answer 15

Right click on a box or group of boxes, press format cells.

Question 16

What is the easiest way to import a .txt file into excel?

Answer 16

Open the file with Excel, which will trigger the import wizard.

Question 17

The main method to import Text/CSV in the MO-200 exam is the …

Answer 17

Get & Transform Method

Question 18

The Get and Transform data method in Excel can be found under the … tab.

Answer 18

data

Question 19

In Excel, the load to option in the import from text/csv pane provides you a range of ….

Answer 19

import options to choose from.

Question 20

The only create connection option in Excel in the import data load to tab does not import the data, but rather creates …

Answer 20

a link between the excel spreadsheet and the file linked.

Question 21

Importing data into a table in Excel reveals the … tab.

Answer 21

Table tools tab.

Question 22

The excel queries tab shows …

Answer 22

tables loaded, and the number of rows loaded.

Question 23

To redock a pane in Excel, one…

Answer 23

double clicks on the title bar of the pane that is undocked.

Question 24

The window that opens when you hit get data from Text / CSV in Excel is called the …

Answer 24

PowerQuery window.

Question 25

Where can the Find & Select Options be primarily found in Excel?

Answer 25

Home Tab -> Editing

Question 26

Where is the Insert Comment option listed in Excel?

Answer 26

In the right click menu exposed when right clicking a cell.

Question 27

How can you define a name range in Excel?

Answer 27

Select a group of cells, input a name for the range in the name box of Excel.

Question 28

Where is the Go To Special command listed in Excel?

Answer 28

Home -> Find & Select

Question 29

What is the big difference between comments on Microsoft 365 vs. Desktop?

Answer 29

Comments are multithreaded.

Question 30

What is the Excel 365 equivalent of comments?

Answer 30

Notes.