MS Excel and Word Basics Quiz

The main functions are Cut/Move, Copy, Undo, and Redo.

You can adjust paragraph alignment using options for line spacing, indentations, and drop caps.

You can create a table using the 'Insert Table' option, and modify it by inserting or deleting rows/columns and applying borders.

<p>Presenter view allows you to see your notes and manage slide timings while presenting to an audience.</p> Signup and view all the answers

<p>A Workbook is an Excel file that contains multiple Worksheets, where each Worksheet consists of rows and columns for data entry.</p> Signup and view all the answers

<p>To use Auto Fill, select the cell with the desired data, grab the fill handle, and drag it across the desired range.</p> Signup and view all the answers

<p>To create a Pivot Table, select your data range and use the 'Insert Pivot Table' option; it summarizes and analyzes large data sets.</p> Signup and view all the answers

<p>Excel offers Bar, Line, Pie, Column, and Area charts, among others.</p> Signup and view all the answers

A collection of individual cells organized in rows and columns. It acts as a building block for organizing data in a spreadsheet.

A collection of multiple worksheets. It's like a container for your data.

A cell is the basic unit of a spreadsheet. It's a box where you can enter text, numbers, or formulas. They are located at the intersection of a row and column.

A horizontal line of cells in a spreadsheet. They run from left to right.

A vertical line of cells in a spreadsheet. They run from top to bottom.

A range is a group of selected cells. It's like a collection of cells you might want to work with together.

A mathematical expression used to perform calculations on values within a cell or a range of cells. They help automate calculations in your spreadsheets.

Pre-defined functions that perform specific calculations. They automate complex calculations, reducing errors and saving you time.