Excel 2.1

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

What is the General format?

The default Excel number format that displays numbers just as they are entered.

.xlsx

file extension for Excel

The range B3:B13 is merged into a single cell. What is the cell reference?

B3

How do you format text so that it is set vertically within a cell?

Click the Orientation button in the Alignment group on the Home tab, and then click Vertical Text.

How do you change the color of a worksheet tab?

Right-click the sheet tab, click Tab Color on the shortcut menu, and then select the color you want to use.

What is the difference between a serif font and a sans serif font?

Serif fonts have extra decorative strokes at the end of each characters. Sans serif fonts do not include these decorative strokes.

Describe the differences between the Accounting format and the Currency format.

The accounting format places the currency symbol on the left edge of the cell, adds a thousands separator, shows values to two decimals places,displays negative values in parentheses, and displays zero values as dashes. The Currency format places the currency symbol to the left of the first digit of the monetary value, adds a thousands separator, shows values to two decimal places, and displays negative numbers with a negative sign.

A cell containing a number displays #######. Why does this occur, and what can you do to fix it?

The number of digits could not fit within the width of the cell. To correct this problem, either increase the width of the cell column or reduce the number of digits to the right of the decimal point.

What is the difference between theme colors and standard colors?

Theme colors are a set of 12 coordinated colors that belong to a theme. Standard colors are 10 colors that are always available regardless of the workbook's theme.

f4

repeat last action


संबंधित स्टडी सेट्स

Basic Insurance Concepts and Principles

View Set

Consumer Behavior Chapter 4 Practice

View Set

RN Concept-Based Assessment Level 2 Online Practice B

View Set

Fundamentals Networking Tech : Mid-Term Exam

View Set

Chapter 59: Care of Patients with Problems of the Biliary System and Pancreas

View Set

Chapter 21 Quiz, Evolution of Population

View Set

Electrophysiology of Neurons SG-Dr. Poole

View Set

Ch 27 Assessment and Management of Patients with Hypertension

View Set

Chapter 7- Memory (book questions)

View Set