Skip to content

Desi banjara

  • I know you have everything in the world so if there is one thing I want to wish for you, it would be good health and more years to spend with your children and grandchildren. Happy Birthday Mom! Birthday Wishes For Mom
  • How to take screenshot in Samsung galaxy S5 Android phones
  • “Investment in travel is an investment in yourself.” ~ Matthew Karsten Quotes
  • Where ever life may take you, whatever endeavors that you choose, I will always be, so very proud of you! Birthday Wishes
  • Happy birthday to the person who is charming, witty and a lot like myself. Birthday Wishes
  • How to take a screenshot on HTC One phones? Android phones
  • AWS DevOps Engineer Professional Exam Practice Questions – 13 AWS DevOps Engineer Professional Exam
  • “Prosperity is not without many fears and disasters; and adversity is not without comforts and hopes.”– Francis Bacon Motivational & Inspirational Quotes

Interview questions – Microsoft Excel

No Comments on Interview questions – Microsoft Excel



1- What is Microsoft Excel?

Microsoft Excel is an electronic spreadsheet program, created by multiple highly skilled engineers from Microsoft. It enables users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and column.

2- How do you create a spreadsheet in Microsoft Excel?

When you start Excel without specifying a document to open you get a blank workbook in a new workbook window.

This workbook, temporarily named Book1, contains three blank worksheets
(Sheet1, Sheet2, and Sheet3). To begin to work on a new spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window.



3- How do you save a spreadsheet in Microsoft Excel?

Click the Save button on the Quick Access toolbar or press Ctrl+S; then designate the drive and folder directory where the file should be located.

4- What is the shortcut to put the filter on data in Microsoft Excel?

Ctrl+Shift+L is the shortcut key to put the filter in data.



5- What is the easiest solution to reduce the file size?

  • Find the last cell that contains data in the sheet. Delete all rows and columns after this cell
  • To delete the rows, press the key Shift+Space then press Ctrl+Shift+Down on your keyboard
  • Rows will get selected till the last row. Press Ctrl+- on the keyboard to delete the blank rows
  • To delete the column, Press the key Ctrl+Space then press Ctrl+Shift+Right Arrow key on your keyboard
  • Columns will get selected till the last row
  • Press Ctrl+- on the keyboard to delete the blank columns

6- What is the difference between function and formula in Microsoft Excel?

Formula:- In excel formula are the statement which is written by the user (user-created) to be calculated. A formula can contain values, cell references, defined names, and functions.

Functions:- Functions are in-built codes provided in MS-Excel, such as COUNT, SUM, AVERAGE etc. And, if additional functions are required we can create through VBA. This will carry out an operation of some kind and provide an output value. Functions are used inside formulas.



Interview questions, Microsoft Excel Tags:AVERAGE, COUNT, filter on data, function and formula, Interview questions, Microsoft Excel, MS-Excel, spreadsheet, SUM, worksheets

Post navigation

Previous Post: Interview questions – Microsoft Word
Next Post: Best Get Well Soon Wishes / Messages

Related Posts

  • Interview question: What is the difference between ref and out parameters? C# development
  • Interview question: What is the purpose of “as” operator in C#? C# development
  • ASP.Net MVC Interview Questions ASP.Net MVC
  • Interview question: In how many ways you can pass parameters to a method? C# development
  • Asp.Net WebApi Interview Questions ASP.NET Web API
  • Interview question: What are primitive data types in C#? C# development

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *



Archives

  • June 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • April 2020
  • December 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • January 2018
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • August 2015
  • May 2015
  • April 2014
  • November 2013

Categories

  • Acer
  • Amazon AWS Certification Exam
  • Amazon Kindle
  • Android phones
  • ASP.Net MVC
  • ASP.NET Web API
  • AWS DevOps Engineer Professional Exam
  • AZ-300: Microsoft Azure Architect Technologies Exam
  • Best Wishes Messages
  • birthday messages for boyfriend
  • Birthday messages For Girlfriend
  • Birthday Wishes
  • Birthday Wishes For Mom
  • Business
  • C# development
  • Cameras
  • Canon
  • Cloud
  • Cloud services
  • digital-cameras
  • Diwali
  • Entrepreneurship
  • eReaders
  • Family Quotes
  • Family Quotes
  • Friendship Quotes
  • Gadgets
  • Games
  • Get Well Soon Messages
  • GIT
  • Good Morning Wishes
  • Google
  • Gratitude Quote
  • Guru Nanak Jayanti
  • Halloween
  • Happiness Quote
  • Happy Diwali Wishes
  • Happy Independence Day Wishes
  • Happy New Year Wishes
  • HTC
  • HTC One
  • HTML
  • I Miss You Messages
  • Inspirational Quotes
  • Inspirational Travel Quotes
  • Interview questions
  • IT/Software development
  • Leadership Quote
  • Life lessons
  • Love Quotes
  • Love shayari
  • Messages
  • Microsoft AI-900 Certification Exam
  • Microsoft AZ-104 Certification Exam
  • Microsoft AZ-204 Certification Exam
  • Microsoft AZ-900 Certification Exam
  • Microsoft Azure
  • Microsoft Azure certifications
  • Microsoft Exam AZ-220
  • Microsoft Excel
  • Microsoft Office
  • Microsoft word
  • Mobile phones
  • Motivational & Inspirational Quotes
  • Nature Quotes
  • Nexus
  • Nikon
  • Pixels
  • PL-200: Microsoft Power Platform Functional Consultant Certification
  • PL-900: Microsoft Power Platform Fundamentals
  • postman
  • Quotes
  • Robin Sharma
  • Samsung Galaxy S5
  • Self improvement quotes
  • Self-Confidence Quote
  • SonarQube
  • Sony PlayStation 4
  • SQL
  • SQL Server
  • Success Quotes
  • Travel Quotes
  • Uncategorised
  • Uplifting Quotes
  • WCF (Windows Communication Foundation)
  • Web development
  • Wishes
  • Wishes for Newborn Baby

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org



Recent Posts

  • PL-200: Microsoft Power Platform Functional Consultant Certification – Exam Practice Questions
  • SonarQube – Static code analysis
  • Microsoft PL-900 Certification Exam Practice Questions – 2
  • Microsoft AZ-204 Certification Exam Practice Questions – 1
  • AWS DevOps Engineer Professional Exam Practice Questions – 14

Recent Comments

  • Yosianus on Error while sending json model in POST request to web API service using postman
  • “A problem is a chance for you to do your best.”– Duke Ellington Motivational & Inspirational Quotes
  • “Once a year, go someplace you’ve never been before.” – Dalai Lama Quotes
  • “Shyness has a strange element of narcissism, a belief that how we look, how we perform, is truly important to other people.” Andre Dubus Motivational & Inspirational Quotes
  • I know that the most special day in your life is my birthday. But today we are celebrating the most special day in my life – Your birthday. Happy birthday mom. Birthday Wishes For Mom
  • Family quotes – Mothers are the people who love us Family Quotes
  • Microsoft AI-900 Certification Exam Practice Questions Microsoft AI-900 Certification Exam
  • Inspirational Quotes – I’ve missed more than 9000 shots in my career Inspirational Quotes
  • “Tough times never last, but tough people do.”– Robert H Schuller Motivational & Inspirational Quotes

Copyright © 2022 Desi banjara.

Powered by PressBook News WordPress theme