I Hate CBT's

View Original

Create A Header With Exploring Series In The Left Section

Question: Type Souvenir Program in cell A8.

Type Soundtrack CD in cell A9, and then press ENTER [remaining data will autocomplete].

Select cell A1 and then spell check the worksheet. When prompted, change the misspelling of Suivineer to Souvenir.

Answer: type in cell a8

type in a9

go to review-spellcheck

Question: Enter 101 in cell B5, and then press CTRL+ENTER.

Use the fill handle to copy the value from cell B5 to the cells B6 through B10.

Use Fill Options to change the values to a series.

Answer: type in b5

click plus sign to copy down

and pop up in bottom right - check series

Question: Enter the value ​0.15​ in cell ​G5​, and then press ENTER [remaining data will autocomplete].

Enter the date ​​9/1 in cell ​A2​, and then press ENTER.

Clear the formatting in cell ​A2​.

Enter the date 9/1/2021 in cell ​A2​, and then press CTRL+ENTER.

Answer: type data

type data

home tab-editing-eraser tab-clear format

Question: On the worksheet, make cell A1 the active cell and then simultaneously replace all occurrences of the value 0.05 with the value .1. Close any open dialog boxes.

Answer: click the cell

find and select- replace all

Question:

Answer: