AnswersCR Computer Applications IIGetting Started with Excel

Getting Started with Excel Answers

22 verified answers3 views
1
Free Preview

Use the table and the drop-down menus to order the steps.

Answers:
Click on the New tab.:Step 2
Click on the Save or Save As tab.:Step 6
Click on the Blank workbook image.:Step 3
Type data into the columns and rows.:Step 4
Create file name and choose location of file.:Step 7
2
Free Preview

Step 2X Step 3Step 4✔ Step 6Step 7

A
Step 2
B
X Step 3
C
Step 4
D
✔ Step 6
E
Step 7
3

X Step 2✔ Step 3X Step 4Step 6Step 7

A
X Step 2
B
✔ Step 3
C
X Step 4
D
Step 6
E
Step 7
4

X Step 2Step 3✔ Step 4Step 6X Step 7

A
X Step 2
B
Step 3
C
✔ Step 4
D
Step 6
E
X Step 7
5

SaveX Save As✔ both Save and Save As

A
Save
B
X Save As
C
✔ both Save and Save As
6

formulaX label✔ value

A
formula
B
X label
C
✔ value
7

formula✔ labelX value

A
formula
B
✔ label
C
X value
8

Use the drop-down menu to complete the steps for using the Autofill feature.

Answers:
Click the .:cell
Click the .:fill handle
Drag the to the desired range.:fill handle
9

Which statement compares the Autofill and Flash Fill features?

A
Only the Flash Fill feature is based on a recognizable pattern.
B
Only the Flash Fill feature can combine data from other cells.
C
Only the Autofill feature automatically adds data to the workbook.
D
Only the Autofill feature is available on the desktop version of Excel.
10

Jose needs to find out how to delete cells from his workbook.Which method is the quickest way for Jose to get step-by-step directions?

A
Do research on the internet.
B
Press F1 and type “delete cells” in the search bar.
C
Click the ? on the top-right corner in the Backstage View.
D
Type “delete cells” in the “Tell me what you want to do” bar.
11

Which steps do you need to follow to create a new Excel workbook? Check all that apply.Click the Create tab.Click the New tab.Click the New Workbook tab.Go to the Backstage View.

A
Click the Create tab.
B
Click the New tab.
C
Click the New Workbook tab.
D
Go to the Backstage View.
12

Use the drop-down menu to identify which command is used to do the activities.

Answers:
Saving updates on a workbook::both Save and Save As
Saving a workbook on OneDrive::Save As
Changing the file name of an existing workbook::Save As
Saving an existing workbook in a different location::Save As
Assigning an initial location for the workbook to be saved::both Save and Save As
13

Why does the phrase "compatibility mode” appear when opening a workbook?

A
The workbook was created using Excel 2019.
B
A version older than Excel 2019 was used to create the workbook.
C
A version newer than Excel 2019 was used to create the workbook.
D
The workbook was created using Word 2019.
14

Gina’s teacher has sent her a Word document that contains the names of all the students who are participating in the Spelling Bee. Her teacher wants her to enter these names in a spreadsheet.Which strategy is the best way for Gina to enter these names?

A
by typing the names one by one down a column in the Excel spreadsheet
B
by typing the first two names in a column and then using the Autofill feature
C
by typing the names in two different columns and then using the Flash Fill feature
D
by copying the names from the Word document and pasting them into the Excel spreadsheet
15

✔ formulalabelvalue

A
✔ formula
B
label
C
value
16

Save✔ Save AsX both Save and Save As

A
Save
B
✔ Save As
C
X both Save and Save As
17

X cell✔ fill handleformula bartoolbar

A
X cell
B
✔ fill handle
C
formula bar
D
toolbar
18

cell✔ fill handleformula bartoolbar

A
cell
B
✔ fill handle
C
formula bar
D
toolbar
19

Save✔ Save Asboth Save and Save As

A
Save
B
✔ Save As
C
both Save and Save As
20

Save✔ Save AsBoth Save and Save As

A
Save
B
✔ Save As
C
Both Save and Save As

Did you find these answers helpful?

More from this Course

Instruction
16 verified answers

Performing Calculations

Assignment
6 verified answers

Getting Started with Excel

Instruction
17 verified answers

Modifying a Worksheet