C268 Spreadsheets Exam Questions with Correct Answers

C268 Spreadsheets Exam Questions with
Correct Answers
Fill Feature

Select cell, Home tab, Edit Group, Fill Button, Series button

AutoFill Feature

Similar to Fill Feature; Select chosen cells, Home tab, Edit Group, Fill Button, Series Button,

AutoFill Feature

Resize Cells

Select cell, Home tab, Cell Group, Format Button

Hide & Unhide Feature

Select Column/Row, Home Tab, Cell Group, Format Button, Hide & Unhide Button

Insert Worksheet Feature

Home Tab, Cell Group, Insert Button, Insert Sheet Button

Delete Worksheet Feature

Select Cell in Worksheet, Home Tab, Cell Group, Delete Button, Delete Sheet

Reuse Cell Format Feature

Select Cell, Home Tab, Clipboard Group, Format Painter Button, Select Destination Cell

Clear Cell Format Feature

Select Cell, Home Tab, Editing Group, Clear Formats Button

Page Headers/Footers Feature

, Page Layout Tab, Page Setup Group, Print Titles Button, Header/Footer tab in popup window

Sorting Feature

Select Cell, Data Tab, Sort & Filter group, Quick Sort Ascending Button OR Sort Button (for

multiple sorts)

Filter Feature

Select cell, Data Tab, Sort & Filter group, Filter button

Relative Cells

A1, column and cell will change

Absolute Column Cell

$A1, only row is relative and will change

Absolute Row Cell

A$1, only column is relative and will change

Absolute Cell

$A$1, both column and row are absolute and will NOT change

Trace Precedents/Dependents Feature

find which formulas or functions reference a particular cell; Formula Tab, Formula Auditing

Group

SUMIF, AVERAGEIF Functions

range to find criteria, criteria to search for in the range, sum_range to calculate from

VLOOKUP Function