Exam 1

Question 1

Control-n

Answer 1

Starts a new blank workbook

Question 2

Control-b

Answer 2

Uses bold text

Question 3

Control-I

Answer 3

Uses italic text

Question 4

How to get a number as a square

Answer 4

Format cells > font > check superscript box

Question 5

Path to create a custom list

Answer 5

File> options > advanced> edit custom lists

Question 6

Tool to identify a variance while keeping track of data already verified

Answer 6

Conditional formatting

Question 7

Most commonly used function in excel

Answer 7

SUM

Question 8

Excel does not allow _________ in numeric format

Answer 8

Leading zeros

Question 9

What do cells with comments look like?

Answer 9

Small red triangle in upper right hand corner

Question 10

Control-;

Answer 10

Shortcut to show current date

Question 11

Control-:

Answer 11

Shortcut to show current time

Question 12

How to duplicate a file

Answer 12

View> new window

Question 13

What group of characters does excel not know?

Answer 13

The alphabet

Question 14

What is the wildcard symbol for filters?

Answer 14

Asterisk *

Question mark

Question 15

Control-End

Answer 15

Takes you to the last value in the data

Question 16

COUNT function

Answer 16

Counts cells with numbers

Question 17

COUNTA function

Answer 17

Counts every cell that is not empty

Question 18

Control-A

Answer 18

Opens function arguments dialog box

Question 19

You cannot use logical functions nested inside _____ or _______

Answer 19

SUMIF, COUNTIF

Question 20

INT function

Answer 20

Rounds a figure down to nearest whole number

Question 21

RAND function

Answer 21

Gives a random value between 0 and 1

Question 22

LEN function

Answer 22

Counts number of characters in text

Question 23

FIND function

Answer 23

Returns position of specified text

Question 24

EXACT function

Answer 24

Returns True if two specified cells are the same or else False

Question 25

CHAR function

Answer 25

Returns character from the number specified

Question 26

CODE function

Answer 26

Returns the number from the character specified

Question 27

TEXT function

Answer 27

Changes a number into a text

Question 28

VALUE function

Answer 28

Changes text into a value

Question 29

How to clear filters and add back filtering option

Answer 29

Data> click filter button twice (in the sort and filter area)

Question 30

How to create a copy of a sheet

Answer 30

Right click tab, move or copy, check create a copy box

Question 31

How to set up filters by within rows or columns

Answer 31

Data> Advanced (sort and filter area)

Question 32

How to hide formulas so that they cannot be seen but are still used

Answer 32

Right click column, hide | Home>cells>format>hide and unhide

Question 33

How to lock cells/hide formulas

Answer 33

Right click>format cells> protection> check locked or hidden

Question 34

How to protect or block altering or selecting cells

Answer 34

Review>protect sheet>enter password and select protection options

Question 35

How to add a password to a file

Answer 35

File>save as> protect workbook> encrypt with password

Question 36

How to get to insert function/ the function palette

Answer 36

Home>editing tab> auto-sum drop down> more functions